Icon

Activity 2 [Room Utilization]

Step 1

Data Ingestion

Step 2

Data Cleaning and Transformation

Step 3

Feature Engineering & Data Mining

Step 4

Aggregation and Pattern Discovery

Step 5

Visualization

Subject Offerings
Excel Reader
Rooms
Excel Reader
Join by "Room"
Joiner
Remove unnecessarycolumns
Column Filter
Replace missingvalues with 0
Missing Value
Calculate UtilizationRate
Math Formula
Classify if course isin "Home Campus","Displaced", or "SMS"
Rule Engine
Exclude "Sandejas Gym"
Row Filter
Utilization Rate by Building
GroupBy
Merge SMIT and SMIT-CDPto just SMIT
String Replacer
Students at Home Campus vs Displaced per School
Bar Chart
Merge all Taftcampuses into just"Taft"
String Replacer
Room Utilization by Campus
Bar Chart
No. of StudentsDisplaced vs at Home Campus by School
Pivot
# of StudentsDisplaced by School
GroupBy
Sorter

Nodes

Extensions

Links